--    Author    : ERHAO
--    Name      : ODS.IBAB_INFO.HQL
--    Functions : 
--    Purpose   : Daily saving the variation data from stg
--    Revisions or Comments
--    VER        DATE        AUTHOR           DESCRIPTION
--   ---------  ----------  ---------------  ------------------------------------
--    1.0        2018-04-13  ChenErHao          1.CREATE THE PROCEDURE
--
INSERT OVERWRITE TABLE ODS.IBAB_INFO PARTITION (DATA_DATE = '20180331' ,DATA_SRC_ORG = 'C1078851000017')
SELECT
FIN_ORG_NO
,TRADE_OPPO_ORG_NO              
,TRADE_OPPO_ORG_CODE
,TRADE_OPPO_DEPARTMENT
,BS_TYPE
,BUSINESS_TYPE
,DUEBILL_NO
,VALUE_DATE
,MATURITY_DATE
,CCY
,ACTUAL_BAL
,IF_FLOAT
,RATE
,BASE_RATE
,TRADE_WAY
,GUARANTY_TYPE
,STATUS
,FIVE_CLASS
FROM 
	STG.IBAB_INFO  STG
WHERE 
	STG.DATA_SRC_ORG = 'C1078851000017' AND DATA_DATA='20180331'
;
